UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xjh9c7vy6hQ8ciCkZgDoDDM8qsQ+T+wKcTqJbwKS2l0='
WHERE
key_id = '56e4131ae9a17df54a1643da486bc25b0efe19c6140038c3ab3a06ba173f7629'
AND (
token = 'Xjh9c7vy6hQ8ciCkZgDoDDM8qsQ+T+wKcTqJbwKS2l0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)