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