UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9sG87ycU0fAPJbiLVt4PbM/6/YN65kcu+jbq/ie+gw='
WHERE
key_id = '0b38422945a68ae7207f68d43f64eb3cb20464190241febe49f27987e7fcf070'
AND (
token = 'h9sG87ycU0fAPJbiLVt4PbM/6/YN65kcu+jbq/ie+gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)