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