UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0eZXRpv6DPIBvtx6G06M00GJoFjCysoxuPv+Lj+zUWg='
WHERE
key_id = '6b6aa13ad91901d25afc5d3a9e22688fc0608319fb611c2e040c037f13f649c1'
AND (
token = '0eZXRpv6DPIBvtx6G06M00GJoFjCysoxuPv+Lj+zUWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)