UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+iHvy8cf3NyBWmVt1IozKnS7bWyYV/yqd5stTX8PyQM='
WHERE
key_id = '1199b59c229c00c095114bc37ff5da2a583376f3c0f2477504b851bcefa5746a'
AND (
token = '+iHvy8cf3NyBWmVt1IozKnS7bWyYV/yqd5stTX8PyQM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)