UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8OQSfuq6LCo15USOjutCIFhOV55ynTC4Wl38mStixQE='
WHERE
key_id = '593b37b1ae13d6bbe6303608fe8bd29b9116c17adccc872caff57748eca55660'
AND (
token = '8OQSfuq6LCo15USOjutCIFhOV55ynTC4Wl38mStixQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)