UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZGq0IyMxxb7nhbGOoZiygCalP9GxpS93nDBmKpPXawA='
WHERE
key_id = '76cd0767e7b2964f00b9b468448e95b7c426b77d3186000515f1e822a0fe2edd'
AND (
token = 'ZGq0IyMxxb7nhbGOoZiygCalP9GxpS93nDBmKpPXawA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)