UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UGshAK19SZk1coxL5mOWyLSWuUTP2BwROrNbk2IIUlU='
WHERE
key_id = '1d059c8834af94f1b7ba91694a6c8214f3ebe98a2003d3ab3299f53d25d44ba6'
AND (
token = 'UGshAK19SZk1coxL5mOWyLSWuUTP2BwROrNbk2IIUlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)