UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VWxeA4jhbhs3B6T6J8WF5advEaqD5wv7/sXPFNrWRTY='
WHERE
key_id = 'fc22dce166c9dcfdeea2dcd9cc8012d4d302256d71224114120400e61527c6da'
AND (
token = 'VWxeA4jhbhs3B6T6J8WF5advEaqD5wv7/sXPFNrWRTY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)