UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pivYAgcLLg2dp6fDxUMuIl0I2frMgq5P/uG4HdI/kcs='
WHERE
key_id = 'be7e35da6e7c4155301a726febd724becdb1dd28b55aaf055562fde699eae71a'
AND (
token = 'pivYAgcLLg2dp6fDxUMuIl0I2frMgq5P/uG4HdI/kcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)