UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HZrcZ3RZDuEEGLIDaMjqvvIJ4+7frAWEeXV0+H+Q63I='
WHERE
key_id = '2d6cc94c5d9a0ba6a7c1716c51de2e15df7fe769e7c1564eb4cf59fb6afa3a49'
AND (
token = 'HZrcZ3RZDuEEGLIDaMjqvvIJ4+7frAWEeXV0+H+Q63I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)