UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r0p8BUS5qPmrxLXhXkWI14jdXxyLAkhtJjNUBWslNn8='
WHERE
key_id = '10f29ec063c4de547638ef4fd640ed7464a7defa9c2a64a973df1630470b5d95'
AND (
token = 'r0p8BUS5qPmrxLXhXkWI14jdXxyLAkhtJjNUBWslNn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)