UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7EkmYpBKfv6LqFNyTFn41O6gfpyS0LTCARsf8CyvPTw='
WHERE
key_id = 'ac702d1e3ebe398a29cab673150fe203dfa49bf71ed9fed25e0036c0b79cffca'
AND (
token = '7EkmYpBKfv6LqFNyTFn41O6gfpyS0LTCARsf8CyvPTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)