UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D7U4Yf5Zs95K51u8QAXr7HmPpsrkPhWQS9/L0Dki3rk='
WHERE
key_id = '9eb78c7699c440d5ab7495fbd6ca23b2e84bc682b76e13a069fe4f2a8a0056a6'
AND (
token = 'D7U4Yf5Zs95K51u8QAXr7HmPpsrkPhWQS9/L0Dki3rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)