UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Bz/VY91KUK6WRyX8HN/Npt5dcp6lm74P0XX7+rdWXI='
WHERE
key_id = 'aa3b4ba33f86ea1747595c7841ac20512876ea06d4da47a38c32e78638c265e9'
AND (
token = '0Bz/VY91KUK6WRyX8HN/Npt5dcp6lm74P0XX7+rdWXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)