UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHQl7oALHN0gehvO52AONy8J+bUNDmxDVEVGg1G2XBM='
WHERE
key_id = 'e8fd3a06c8f05b9636012d07931b416cac8d37da31d29917b1891e617ce8c35a'
AND (
token = 'eHQl7oALHN0gehvO52AONy8J+bUNDmxDVEVGg1G2XBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)