UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tU/9vVLluVpPalqJyjSY7Zj3VZ10DO4/5GRPJ4Jc0eY='
WHERE
key_id = 'e0b1187717f8bfa6b132b2196374b7376baeeb0f8e48d153057e21b15bd6250f'
AND (
token = 'tU/9vVLluVpPalqJyjSY7Zj3VZ10DO4/5GRPJ4Jc0eY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)