UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Kiku1o2PJJIRha0e0Wj4aIZsjlUNJGuB0lS9cvJ9aM='
WHERE
key_id = 'eeab9aaffe8ac090782bfb8e3933dd32e0ed044bed24f5f61df2f907cb9e2520'
AND (
token = '5Kiku1o2PJJIRha0e0Wj4aIZsjlUNJGuB0lS9cvJ9aM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)