UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3FGVaXhpVB+1OPrdTAXt0ScIHK+sRG/P4Xsh55z3ZcM='
WHERE
key_id = 'a1d7d3dfdf6598d5c936d9ea343cc1d608d0ddef5375ed1d29d534c565c4972a'
AND (
token = '3FGVaXhpVB+1OPrdTAXt0ScIHK+sRG/P4Xsh55z3ZcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)