UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gS8Q5eqOHWYENwjS5l/DHjd2hLT+8MYzbZerMDvI89I='
WHERE
key_id = '9dcb61d1e8da764798b0677202ae5f3b31d9b00a97a74ebca209764e5102fa15'
AND (
token = 'gS8Q5eqOHWYENwjS5l/DHjd2hLT+8MYzbZerMDvI89I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)