UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+akXbJRCuZGgWiVnI79y/M08wii3lYHQGHt4dNFEJ+8='
WHERE
key_id = '0e2ca48ca42273c4ce769ace7b79839dad77421f64286c17da48fe23f901a264'
AND (
token = '+akXbJRCuZGgWiVnI79y/M08wii3lYHQGHt4dNFEJ+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)