UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4x5cQV2uHwOhFuFrTbzmNLs/TpivPWrHQ7XV3eyIeA='
WHERE
key_id = '3b2a42b945e6b5dbbd77fca057e681ad6d45b1f499c898d90451c1e5493d86ff'
AND (
token = 'I4x5cQV2uHwOhFuFrTbzmNLs/TpivPWrHQ7XV3eyIeA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)