UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BN8E6k0CNjMcVlE7MAZ7Hw+PVvwUGoVqK9qghgF2zZo='
WHERE
key_id = '1b8533d729111e418032ad6702cdc0cc2892e5237048de18050e7121bdae701e'
AND (
token = 'BN8E6k0CNjMcVlE7MAZ7Hw+PVvwUGoVqK9qghgF2zZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)