UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B2AGR1gQqIY/DQsbke1U3zYsavYdF8feyadv63QvVgk='
WHERE
key_id = 'e5267d5d9582edff7e1c406ba9e0d25e2d8723c9daebbf14361f38eb72b5fc97'
AND (
token = 'B2AGR1gQqIY/DQsbke1U3zYsavYdF8feyadv63QvVgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)