UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NYUFr3Z4Q/IJDru0HPxyfZwYpshuFDcMJko7b93C/X0='
WHERE
key_id = 'dcc38c3380993650e3b6fbb53d6cc019a63847d56a853a7892ad0542c89f65fe'
AND (
token = 'NYUFr3Z4Q/IJDru0HPxyfZwYpshuFDcMJko7b93C/X0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)