UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pFdQMItQE7lPD/REpuzCwDCQMsUfi8TYH0wwIMM6BPw='
WHERE
key_id = 'a515a2f7c3a6a79dc18dd440742abc91e872e8c1659fa412bfbb3d8c0d3d695e'
AND (
token = 'pFdQMItQE7lPD/REpuzCwDCQMsUfi8TYH0wwIMM6BPw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)