UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YphVSjaM1goxc311tgqycJj1+EKZNUzol49OEIyToqw='
WHERE
key_id = '29131087991961df6a50dd920b5a1af8059fce346076c081bd241f167b4ef4c5'
AND (
token = 'YphVSjaM1goxc311tgqycJj1+EKZNUzol49OEIyToqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)