UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EEGnIYpoKHklH9uJcuZS9CtWrJoVgod0Vu0xNgozels='
WHERE
key_id = 'a05aa4e2d4047065c8c82c719cd0f79d255262d4467a389ea30195a5134f288c'
AND (
token = 'EEGnIYpoKHklH9uJcuZS9CtWrJoVgod0Vu0xNgozels='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)