UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4Ny/A+/iBd90mn5mn/yrT2Lf9TejODE0aiUi2PE+oA='
WHERE
key_id = 'f893819262836f29a75b449f03a19a05ac90e008d9d74ff0a5ac03d5f18fb21f'
AND (
token = 'C4Ny/A+/iBd90mn5mn/yrT2Lf9TejODE0aiUi2PE+oA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)