UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccKNDs5k01nHean8a+yy+uku4XNK9ag/0Fo2L4QNILs='
WHERE
key_id = '20f44483cc37f8e2a161cace049c2e01ceedff004488689cb1eefe418dcc4a44'
AND (
token = 'ccKNDs5k01nHean8a+yy+uku4XNK9ag/0Fo2L4QNILs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)