UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '179mK+T92AwVBUINjHQOb0rM69ckLacN5hJvNpaZRjA='
WHERE
key_id = 'a2e83c06d37c7228f13595b556df33b16b93045a81b680a72813d48e66fda542'
AND (
token = '179mK+T92AwVBUINjHQOb0rM69ckLacN5hJvNpaZRjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)