UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QpCjEyYAq4zdblLUzKgv/M6C9eNUmJn93myI+aC4dgs='
WHERE
key_id = '003589b9a7819222f176391131030bdc22f12f97ce08d4021f8444c4144586ca'
AND (
token = 'QpCjEyYAq4zdblLUzKgv/M6C9eNUmJn93myI+aC4dgs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)