UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nLl47hBBMwd50biEd5qMwopbjQy/k8EhCNjiY3vpMhU='
WHERE
key_id = '4284c033ac8838dd0f1503fe468512080454e6984934202843f96ee9ae9e8211'
AND (
token = 'nLl47hBBMwd50biEd5qMwopbjQy/k8EhCNjiY3vpMhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)