UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eELOQfdNyQWR9kk1yhzYpNkzDyNL81LJxtt3WuCfPfw='
WHERE
key_id = '31b7a04d6e937801675abb9907e935e2726979b456c8f76e832de1f541572876'
AND (
token = 'eELOQfdNyQWR9kk1yhzYpNkzDyNL81LJxtt3WuCfPfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)