UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWBH8XnliyfoiKHCQ7ziXosXyMK/DpU362zLtvARPiI='
WHERE
key_id = '8ff4b8ae4289c762ffc6c765131b857e48f533a225aadb326e0b2c621d5c0de1'
AND (
token = 'nWBH8XnliyfoiKHCQ7ziXosXyMK/DpU362zLtvARPiI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)