UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYIImeMHppQMo1RSOUoJOXIvEl9zf2eBkexO1xBp+fQ='
WHERE
key_id = '20e734627527230cde74bcac722f68a1ec9daf67df1d5368bbc773ff97bd0391'
AND (
token = 'ZYIImeMHppQMo1RSOUoJOXIvEl9zf2eBkexO1xBp+fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)