UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z6J+IJEkwJynf5VQyA4c7WXNRlTMIprT3ZOwnvjzMN8='
WHERE
key_id = '2ef931c46b7962f029019f7bdf507f13cb0f12b02e08e6e502dd9c893c915843'
AND (
token = 'Z6J+IJEkwJynf5VQyA4c7WXNRlTMIprT3ZOwnvjzMN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)