UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i8i92eVP58dQfNA2mfBZpUjZukE9hWEijKLSMex7AlA='
WHERE
key_id = '90b40604307a358d68cba5af053a73953f03ed12514379108bdd1c5758e8b46b'
AND (
token = 'i8i92eVP58dQfNA2mfBZpUjZukE9hWEijKLSMex7AlA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)